# coding gbk

import sqlite3

conn = sqlite3.connect('identifier.sqlite')
print("Opend database successfully")
c = conn.cursor()
c.execute('''create table user_test    (id int,    user_name text);''')

print("Table created successfully")
conn.commit()
v_sql = "insert into user_test(id, user) values(1, 'wangbo')"
c.execute(v_sql)
conn.commit()
conn.close()

